So I have a members table that I built for other uses, and it snags the U_Number and U_Username from the Users table of Threads and uses them.
Not ALL Threads Users are in this private Users table.
What sort of SELECT Query would I write that would look at the w3t_Users and my_members tables - and give me ONLY the U_Number selections that are NOT in the my_members table?
I tried SELECT DISTINCT to no luck, but could have written it wrong. Never have tried something like this before....here is what I have, it obviously does not work!
SELECT DISTINCT U_Number, U_Username, U_Laston FROM w3t_Users,my_members WHERE mem_forumid NOT LIKE U_Number ORDER BY $order
